[dbo].[GatewayTypeRef]

Property	Value
Created	10:31:23 AM Tuesday, March 02, 2010
Last Modified	1:17:32 PM Thursday, February 23, 2012

Name	Data Type	Max Length (Bytes)
GatewayTypeCode	nchar(4)	8
GatewayTypeDesc	nvarchar(50)	100
GatewayComponentKey	uniqueidentifier	16
BusinessObjectName	nvarchar(50)	100
EditGuiContentCode	nvarchar(100)	200

	Name	Columns	Unique
	PK_GatewayTypeRef	GatewayTypeCode
	IX_GatewayTypeRef_GatewayComponentKey	GatewayComponentKey

Name	Columns
FK_GatewayTypeRef_ComponentRegistry	GatewayComponentKey->[dbo].[ComponentRegistry].[ComponentKey]

SQL Script

CREATE TABLE [dbo].[GatewayTypeRef]
(
[GatewayTypeCode] [nchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GatewayTypeDesc] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GatewayComponentKey] [uniqueidentifier] NOT NULL,
[BusinessObjectName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EditGuiContentCode] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[GatewayTypeRef] ADD CONSTRAINT [PK_GatewayTypeRef] PRIMARY KEY CLUSTERED ([GatewayTypeCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_GatewayTypeRef_GatewayComponentKey] ON [dbo].[GatewayTypeRef] ([GatewayComponentKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GatewayTypeRef] ADD CONSTRAINT [FK_GatewayTypeRef_ComponentRegistry] FOREIGN KEY ([GatewayComponentKey]) REFERENCES [dbo].[ComponentRegistry] ([ComponentKey])
GO